package com.dingding.service.user.core.sql;

public class TaxiConfirmArriveSQL {

	/**
	 * 确认到达推送消息查询SQL
	 * 
	 * @author YHQ
	 * 
	 */
	public static final String PASSENGER_PAY_PUSH = "SELECT u.aliasId,u.loginEquipment,ud.tellphone,ud.nickName AS 'passengerName',udp.nickName,v.lisencePlate FROM userlogin u INNER JOIN userdetail ud ON u.uid = ud.loginId INNER JOIN userdetail udp ON udp.loginId = ? LEFT JOIN vehicleinfo v ON udp.loginId = v.loginId WHERE u.uid = ?";

	/**
	 * 确认到达sql
	 * @author YHQ
	 * @since V2.5.6
	 */
	public static final String PASSENGER_PAY_TAXI_PUSH = "SELECT u.aliasId,u.loginEquipment,ud.tellphone,ud.nickName AS 'passengerName',udp.nickName,v.lisencePlate FROM userlogin u INNER JOIN userdetail ud ON u.uid = ud.loginId INNER JOIN specialuserinfo udp ON udp.userId = ? LEFT JOIN specialuservehicleinfo v ON udp.userId = v.userId WHERE u.uid = ?; ";
	
}
